UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Lr6HxlohmLr4uaiYmRwHKx07zfDe3DvBOVjek8lT3HI='
WHERE
key_id = '6ea9029eb8667a937cab0361c3e932ad1028b7335a5f76af9c14daa864621abd'
AND (
token = 'Lr6HxlohmLr4uaiYmRwHKx07zfDe3DvBOVjek8lT3HI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)