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