UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gDfIzJhQbjcVI6ZZW3w6yynglTI7SbETqDHgKcCoL+k='
WHERE
key_id = '1c199b31de3899cdaac546b76def507ce975d547c7940b9c66ec6c31adff828b'
AND (
token = 'gDfIzJhQbjcVI6ZZW3w6yynglTI7SbETqDHgKcCoL+k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)