UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zs+tVyHlqM2WSwkWflwTrcH5E47FM0puhkPkmGciPLw='
WHERE
key_id = '6adc0b5da7296aa88132b61aacb74819f27649a8cbc29c4cbacea3d370c42d06'
AND (
token = 'zs+tVyHlqM2WSwkWflwTrcH5E47FM0puhkPkmGciPLw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)