UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eaG2v0uqA1iIbjztuGXeO1uS8DqKi8hzHkoVz9vjo7A='
WHERE
key_id = '0dc5855118870d3b440dd628808b757e5c3934020eb933820b15e7accef173ce'
AND (
token = 'eaG2v0uqA1iIbjztuGXeO1uS8DqKi8hzHkoVz9vjo7A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)