UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a6TnP+iYFoOelwKwCYm8gYdQEfGgk7Z8tU1J2LLtNuM='
WHERE
key_id = '84a5811089f5a376bf7ef9403fab02ec9b4a9f50902ab038403be4281bf20e1b'
AND (
token = 'a6TnP+iYFoOelwKwCYm8gYdQEfGgk7Z8tU1J2LLtNuM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)