UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EaAPOsxYhOrAu4IoSeAFkIUL+88fPXYJuBBzsHEO5HE='
WHERE
key_id = 'a4ce253fa693b117643b50dc985ea3e6875af5f3c6565c9de7266c397971a86d'
AND (
token = 'EaAPOsxYhOrAu4IoSeAFkIUL+88fPXYJuBBzsHEO5HE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)