UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zkg7ubghoj0fyraokLre8bdDKFjZ96AP+y/TFAKogBI='
WHERE
key_id = 'd8e1751e6bb5cbcccaae48124681d06361cacf973c4023071d139e7d8f3027c6'
AND (
token = 'zkg7ubghoj0fyraokLre8bdDKFjZ96AP+y/TFAKogBI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)