UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oIV9BEvPocJY/+wURSJHfTY3YUJ04KGfuyk50WqyuwY='
WHERE
key_id = 'a7ee0b3da7f6218b52d3f73f732b1e17bff8fe1cf190950ec5ab0839ec353584'
AND (
token = 'oIV9BEvPocJY/+wURSJHfTY3YUJ04KGfuyk50WqyuwY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)