UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pJz47WHg0nVMHaKNnl6kTJZ5tSrs8lZX5u3DWagitfk='
WHERE
key_id = '066426ad36cbe81e2af3a762ec45764ba41959d4cf4e3dc0994419794e516ff5'
AND (
token = 'pJz47WHg0nVMHaKNnl6kTJZ5tSrs8lZX5u3DWagitfk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)