UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wSBNrvlBwc3jRZ8MqpMHi5lrnCdTmwmOO+El/dLiNr8='
WHERE
key_id = 'a88c8fd8e0d79ebe0cb777dde4bd1fb1650f5a2b6fae4919f77b6abb0dd1bf2b'
AND (
token = 'wSBNrvlBwc3jRZ8MqpMHi5lrnCdTmwmOO+El/dLiNr8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)