UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PXMilBZDvp9lJ3SEg21fX5grKW3YRKNADUbcIWHZnEk='
WHERE
key_id = '3e1e43d0bfbd433e043ecbc1557c33930d268c4512d345d35d1b97a728527a9a'
AND (
token = 'PXMilBZDvp9lJ3SEg21fX5grKW3YRKNADUbcIWHZnEk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)