UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BPm4xzZmOfQJpNylBpwG9El3RfRp0M+cSHr3mG3Rd98='
WHERE
key_id = 'f3b12c7486a6e343b4f2d793d9dd71519056f69b6812fd3803736af8857596b5'
AND (
token = 'BPm4xzZmOfQJpNylBpwG9El3RfRp0M+cSHr3mG3Rd98='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)