UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1YQDnDa8GYC2MzrMJGIEletrvDkgNGZNHMuyGs/oMEQ='
WHERE
key_id = '5bdcbd676a4b9474c628962475c7da934151b9569dd37457febea22ddf221d4a'
AND (
token = '1YQDnDa8GYC2MzrMJGIEletrvDkgNGZNHMuyGs/oMEQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)