UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lV1FKCO9bPgzFaF1Lz3gEKOFKjKIT0i7H3aKdc/XLXk='
WHERE
key_id = '02d26f2918c25fd229cbcfb04f9a50650eee79d28db652d7f08db8fd50f82c47'
AND (
token = 'lV1FKCO9bPgzFaF1Lz3gEKOFKjKIT0i7H3aKdc/XLXk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)