UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YTsuG467FIAwhetDF93l2ifTbUzoo187Pl9T6L50xIM='
WHERE
key_id = '42f50b02664bd32ce3160b11ec154a05bb454d92f7574475354a643b58bedbc8'
AND (
token = 'YTsuG467FIAwhetDF93l2ifTbUzoo187Pl9T6L50xIM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)