UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z6uDbYgP/VdN9wec5f/Hsl0mYuS5NVuGQ0Ds68e68XA='
WHERE
key_id = 'b3bd62289c426875bb6751342994647e27d42ab1136092f4f95c343abb24703e'
AND (
token = 'z6uDbYgP/VdN9wec5f/Hsl0mYuS5NVuGQ0Ds68e68XA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)