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