UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oIWjGV4mekP+0oU06V7h50+B2sGmMPf6ob5/m5YrCuk='
WHERE
key_id = 'b3167cc7f2beab1ea7ec6da844153693d39913e213691bc705212eadcc695f70'
AND (
token = 'oIWjGV4mekP+0oU06V7h50+B2sGmMPf6ob5/m5YrCuk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)