UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IFh7PQrM4aKpE+WVHmtB2xWAMwXv7ylxSPDc8qomYDw='
WHERE
key_id = '1f1b43dfb71b3645ef844bdc9be055e6e990d15b867e238c27a444896aa54ff9'
AND (
token = 'IFh7PQrM4aKpE+WVHmtB2xWAMwXv7ylxSPDc8qomYDw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)