UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qqQfZ0QwioMzn0udr35TyykCeujSFh8Eu2aWwPHYVBQ='
WHERE
key_id = 'cefd186725fad4b23abd5a888f89b4b60810e2a1ae05b40ac738638532487e38'
AND (
token = 'qqQfZ0QwioMzn0udr35TyykCeujSFh8Eu2aWwPHYVBQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)