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