UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9RS4tNjCSPJbf46NJ76Ws7sJ1K24sh/fIwIDWXaHKOc='
WHERE
key_id = 'b14f354f2ebb6e774340464c73e6db8a6889486c05627f67345cc03c831293c4'
AND (
token = '9RS4tNjCSPJbf46NJ76Ws7sJ1K24sh/fIwIDWXaHKOc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)