UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3qdM8FocVIJZF9iVkjyrbRiSOV7onLDstk0EnlZFdDE='
WHERE
key_id = '8e86530461f1821a454132f8e5eeb45c2402970df1e686ee8e1cc67d766a8005'
AND (
token = '3qdM8FocVIJZF9iVkjyrbRiSOV7onLDstk0EnlZFdDE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)