UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aV7gpsRx5n2KCBbbrpFnYNpt+yywd+cqe7TZ1inyBOo='
WHERE
key_id = 'ca00b97d55458e8be5ba6fa4a5d4fc8966c227394f4630f3993db146430fef72'
AND (
token = 'aV7gpsRx5n2KCBbbrpFnYNpt+yywd+cqe7TZ1inyBOo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)