UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Yr7ogszjxsGZqBY/Gehi+zi5+VKw/C/L+DHYVZFwVso='
WHERE
key_id = '278873b9ee5ef02edbe751097305ceb9e3ca5f5e469609d41064f68da4402ae1'
AND (
token = 'Yr7ogszjxsGZqBY/Gehi+zi5+VKw/C/L+DHYVZFwVso='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)