UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nr/+4YYRSTlIAgss+qmVwFWopix99s4ZR+aSEkU6Iwg='
WHERE
key_id = '1fe383bb7c310b6116402c6c32b64fde4ccf8fe637d261f4a0b674e7fe7e9b47'
AND (
token = 'Nr/+4YYRSTlIAgss+qmVwFWopix99s4ZR+aSEkU6Iwg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)