UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'capGOJt9vJ2YTQ9S33e2AB/yN6qCXo37swu1/ejo3qw='
WHERE
key_id = '25711b503f2d17ca9cff63e79423b308aec145495739600be07ddbb5311c98a5'
AND (
token = 'capGOJt9vJ2YTQ9S33e2AB/yN6qCXo37swu1/ejo3qw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)