UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i6xkOj+kd3FZrUSfZEqTeoG1mN3X+bHJoE7xWhMf7Mw='
WHERE
key_id = '0d1fd4502dd8c6812ee2d84644033c7e6f20438ba7be226107a51f890fed86c9'
AND (
token = 'i6xkOj+kd3FZrUSfZEqTeoG1mN3X+bHJoE7xWhMf7Mw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)